﻿<%@ Page Language="C#" %>
<%@ Register TagPrefix="IRL" TagName="SideBar" Src="SideBar.ascx" %>
<%@ Import Namespace="IRL.Utilities" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">        
    public const int CURRENT_MODULE = 51;
    
    protected void Page_Load(object src, EventArgs e)
    {
        Security SysAcc = new Security(CURRENT_MODULE);
        // check is authenticate
        SysAcc.Authenticate();
        
        // load reminder count        
        //Mics.loadReminderCount(lblReminderCount);
        
        SideBar1.loadData();
        if (!Page.IsPostBack)
        {
            rebind();
        }
    }

    // bind to datagrid
    void rebind()
    {
        string market = "";
        if (Request.Cookies["office"] != null)
            market = Request.Cookies["office"].Value;
        object connStr = ConfigurationSettings.AppSettings["sqlConn"];
        using(SqlConnection conn = new SqlConnection(connStr.ToString()))
        {
            SqlCommand cmd = new SqlCommand("sp_ListReminders", conn);
            SqlDataReader dr;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@userid", SqlDbType.Int).Value = Request.Cookies["irl_id"].Value;
            cmd.Parameters.Add("@type", SqlDbType.VarChar, 10).Value = "Proposal";
            if (market != "")
                cmd.Parameters.Add("@market", SqlDbType.Int).Value = market;
            conn.Open();
            dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            // bound to datagrid
            grid1.DataSource = dr;
            grid1.DataBind();
            // close reader
            dr.Close();
        }
    }
    
    // showDueIn
    private string showDueIn(object DueDate)
    {
        TimeSpan diff = DateTime.Today - (DateTime)DueDate;
        if (diff.Days == 0)
        {
            return "<b>Today</b>";
        }
        else if ((diff.Days % 7) == 0)
        {
            int diffWeeks = diff.Days / 7;
            if (diffWeeks == 1)
                return "<b>1</b> week overdue";
            else
                return "<b>" + diffWeeks + "</b> weeks overdue";
        }
        else
        {
            return "<b>" + diff.Days + "</b> days overdue";
        }
    }        

    protected void grid1_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            Response.Write(e.Item.Cells[3].Text);
        }
    }

    protected void grid1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            LinkButton lnk = (LinkButton)e.Item.FindControl("cmdMarkComplete");
            lnk.Attributes.Add("onclick", "return markComplete();");
        }
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta name="Description" content="Providing the tools and expertise needed to navigate in the emerging consumer markets of Indochina.">
    <meta name="keywords" content="Research in Indochina, Research Consultants in Indochina, Marketing Research in Indochina, Marketing Research Companies in Indochina, Marketing Consultants in Indochina Research in Vietnam, Research Consultants in Vietnam, Marketing Research in Vietnam, Marketing Research Companies in Vietnam, Marketing Consultants in Vietnam Research in Cambodia, Research Consultants in Cambodia, Marketing Research in Cambodia, Marketing Research Companies in Cambodia, Marketing Consultants in Cambodia Research in Laos, Research Consultants in Laos, Marketing Research in Laos, Marketing Research Companies in Laos, Marketing Consultants in Laos">
    <meta name="robots" content="all">

    <title>Indochina Research</title>
    <link type="text/css" rel="stylesheet" href="../css/global.css" />
    <link type="text/css" rel="stylesheet" href="css/cms.css" />
    
    <script language="javascript">
        function markComplete(){
			var strMsg = "Are you sure you want to mark complete for this item?\n\n" +
							"=========================================\n\n" +
							"Please make sure that an email reminder for this item has been sent.\n\n" +
							"Click OK to continue, or Cancel to halt the execution.";
			return confirm(strMsg);
		}
    </script>

</head>

<body>
<table width="773" border="0" cellspacing="0" cellpadding="0" align="center">
	<tr>
		<td width="765" height="540" align="center" valign="top" style="border:solid 1px #10147e;" >
			<!-- header -->
			<table border="0" cellpadding="0" cellspacing="0" width="100%">
				<tr bgcolor="#F4F4F9">
					<td colspan="3" align="right" style="padding:10px;">
						<b class="blueL">Client Management System</b>
					</td>
				</tr>
				<tr>
					<td class="wave_l">&nbsp;</td>
					<td><img src="images/wave_logo.jpg" width="107" height="83"></td>
					<td class="wave_r">&nbsp;</td>
				</tr>
				<tr>
					<td colspan="3" style="padding:0 20px;">
						<div style="background-color:#bcb3d5; padding:5px 10px;">
							<span style="float:right">

								&nbsp;</span>
							<span class="pathmap">
								<a href="default.aspx" >CPanel</a> :: 
								<a href="default2.aspx" >Ops Files</a> :: 
								Proposal Reminders
						  </span>
						</div>
						<br />
						
						
					</td>
				</tr>
				
			</table>
			
			<!-- body -->
			<form id="DataForm" method="post" runat="server">
			<table border="0" width="100%" cellspacing="0" cellpadding="0">
				<tr>
					<td align="center" valign="top" style="padding-left:20px;">
						<table align="left" border="0" cellspacing="0" cellpadding="0">
							<tr>
								<td valign="top">
								
									<IRL:SideBar ID="SideBar1" runat="server" />
								
								</td>
								<td width="10"><img src="images/spacer.gif" width="10" height="1" /></td>
								<td valign="top">
								    <!-- data row -->
                                    <div style="width:480px; overflow:auto; overflow-y:visible">
									    <asp:DataGrid ID="grid1" CssClass="data" Width="100%" runat="server" CellSpacing="1"
                                            CellPadding="5" BorderWidth="0" GridLines="none" AutoGenerateColumns="false"
                                            OnItemCommand="grid1_ItemCommand">
                                            <HeaderStyle CssClass="header" />
                                            <ItemStyle BackColor="#efefef" />
                                            <AlternatingItemStyle BackColor="white" />
                                            <Columns>
                                                <asp:BoundColumn DataField="ProposalID" Visible="false" />
                                                
                                                <asp:TemplateColumn HeaderText="No">
                                                    <HeaderStyle Width="20" />
                                                    <ItemTemplate>
                                                        <%# Container.ItemIndex+1%>
                                                    </ItemTemplate>
                                                </asp:TemplateColumn>
                                                
                                                <asp:BoundColumn HeaderText="Client Name" DataField="ClientName">
                                                    <HeaderStyle Width="220" />
                                                </asp:BoundColumn>
                                                
                                                <asp:TemplateColumn HeaderText="Project Name">
                                                    <HeaderStyle Width="180" />
                                                    <ItemTemplate>
                                                        <a class="edit" href="saveProposal.aspx?pid=<%# DataBinder.Eval(Container.DataItem, "ProposalID") %>">
                                                            <%# DataBinder.Eval(Container.DataItem, "ProjectName") %>
                                                        </a>
                                                    </ItemTemplate>
                                                </asp:TemplateColumn>
                                                
                                                <asp:TemplateColumn HeaderText="Due in">
                                                    <HeaderStyle Width="120" />
                                                    <ItemTemplate>
                                                        <%# showDueIn(DataBinder.Eval(Container.DataItem, "ReminderDate"))%>
                                                    </ItemTemplate>
                                                </asp:TemplateColumn>
                                            </Columns>
                                        </asp:DataGrid>
                                    </div>
								</td>
							</tr>
						</table>
					</td>
				</tr>
			</table>
			</form>
			<p>&nbsp;</p>
		</td>
		
		<td width="6" class="rightShadow" valign="top">
			<img src="images/white.gif" width="6" height="6" /></td>
	</tr>
	
	<!-- bottom shadow -->
	<tr>
		<td height="6" class="bottomShadow">
			<img src="images/white.gif" width="6" height="6" /></td>
		
		<td width="6" height="6">
			<img src="images/shadow_corner.gif" width="6" height="6" /></td>
	</tr>
</table>

</body>
</html>
